package com.work.farm.dao;

import com.work.crops.pojo.CropsInfo;
import com.work.farm.pojo.TCustFarmlandCropsEntity;
import com.work.farm.pojo.TCustFarmlandDeviceEntity;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

public interface FarmLandDeviceDao extends Mapper<TCustFarmlandDeviceEntity> {

    @Select("SELECT * FROM t_cust_farmland_crops WHERE fid=(SELECT fid from t_cust_farmland_device WHERE cdid=#{id})")
    TCustFarmlandCropsEntity findCropsByDeviceId(Integer id);


}
